<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10" interactivePageBreakByFrame="true"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="NetApp"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Storage Inventory - NetApp</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><list horizontalPagination="true" name="List1" rowsPerPage="5000" refQuery="NetApp Storage">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:25px"/></style><contents/><listColumnRowSpan refDataItem="Storage Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Node"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><list horizontalPagination="true" name="List2" rowsPerPage="5000" refQuery="NetApp Storage">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool/Aggregate"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool/Aggregate"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Redundancy"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Redundancy"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Allocated (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Allocated (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><staticValue>Volume Detail</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="padding-left:5px;width:600px"/></style><contents><list horizontalPagination="true" name="List3" rowsPerPage="5000" refQuery="NetApp Volume">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Thin Provisioned"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Thin Provisioned"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Space Guarantee"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Space Guarantee"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Protection Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Protection Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Volume Allocated (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Volume Allocated (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Volume Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Volume Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="nodeid"/></masterContext><detailContext><dataItemContext refDataItem="vnodeid"/></detailContext></masterDetailLink><masterDetailLink><masterContext><dataItemContext refDataItem="poolid"/></masterContext><detailContext><dataItemContext refDataItem="vpoolid"/></detailContext></masterDetailLink></masterDetailLinks></list></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><staticValue>Disk Detail</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="padding-left:5px;width:600px"/></style><contents><list horizontalPagination="true" name="List4" rowsPerPage="5000" refQuery="NetApp Disk">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Disk"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Disk"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Disk Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Disk Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Disk Speed"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Disk Speed"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Disk Role"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Disk Role"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Disk Status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Disk Status"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Location"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Location"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="nodeid"/></masterContext><detailContext><dataItemContext refDataItem="dnodeid"/></detailContext></masterDetailLink><masterDetailLink><masterContext><dataItemContext refDataItem="poolid"/></masterContext><detailContext><dataItemContext refDataItem="dpoolid"/></detailContext></masterDetailLink></masterDetailLinks></list></contents></listColumnBody></listColumn></listColumns><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="nodeid"/></masterContext><detailContext><dataItemContext refDataItem="nodeid"/></detailContext></masterDetailLink><masterDetailLink><masterContext><dataItemContext refDataItem="poolid"/></masterContext><detailContext><dataItemContext refDataItem="poolid"/></detailContext></masterDetailLink></masterDetailLinks></list></contents><listColumnRowSpan refDataItem="Node"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Table</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>List</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents/></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Storage Name"><listHeader><listRows><listRow><rowCells><rowCell colSpan="4"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Storage Name: </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents></tableCell><tableCell><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents></tableCell><tableCell><contents><textItem><dataSource><staticValue>     Vendor: </staticValue></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents></tableCell><tableCell><contents><repeater name="Repeater1" refQuery="NetApp Storage">
			<contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents></tableCell><tableCell><contents><textItem><dataSource><staticValue>, Family: </staticValue></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents></tableCell><tableCell><contents><repeater name="Repeater2" refQuery="NetApp Storage">
			<contents><textItem><dataSource><dataItemValue refDataItem="Family"/></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents></tableCell><tableCell><contents><textItem><dataSource><staticValue>, Microcode: </staticValue></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents></tableCell><tableCell><contents><repeater name="Repeater3" refQuery="NetApp Storage">
			<contents><textItem><dataSource><dataItemValue refDataItem="Microcode Version"/></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><defaultStyles><defaultStyle refStyle="oh"/></defaultStyles><CSS value="background-color:#8DB4E2;color:#333333"/></style></rowCell></rowCells></listRow></listRows></listHeader></listGroup><listGroup refDataItem="Node"><listHeader><listRows><listRow><rowCells><rowCell colSpan="2"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Node Name: </staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents></tableCell><tableCell><contents><textItem><dataSource><dataItemValue refDataItem="Node"/></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents></tableCell><tableCell><contents><textItem><dataSource><staticValue>     Model: </staticValue></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents></tableCell><tableCell><contents><repeater name="Repeater4" refQuery="NetApp Storage">
			<contents><textItem><dataSource><dataItemValue refDataItem="Model"/></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Node"/></masterContext><detailContext><dataItemContext refDataItem="Node"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents></tableCell><tableCell><contents><textItem><dataSource><staticValue>, Serial Number: </staticValue></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents></tableCell><tableCell><contents><repeater name="Repeater5" refQuery="NetApp Storage">
			<contents><textItem><dataSource><dataItemValue refDataItem="Serial Number"/></dataSource><style><CSS value="font-size:11px;color:#333333"/></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Node"/></masterContext><detailContext><dataItemContext refDataItem="Node"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><defaultStyles><defaultStyle refStyle="ih"/></defaultStyles><CSS value="background-color:white;text-align:left"/></style></rowCell><rowCell><contents/><style><defaultStyles><defaultStyle refStyle="ih"/></defaultStyles><CSS value="background-color:white"/></style></rowCell></rowCells></listRow></listRows></listHeader></listGroup></listGroups></list></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>7.13 Physical Storage Inventory - NetApp</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="NetApp Storage">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
*
FROM
(

SELECT
dwh_inventory.storage.name as 'Storage Name',
dwh_inventory.storage.manufacturer as 'Vendor',
dwh_inventory.storage.family as 'Family',
dwh_inventory.storage.microcodeversion as 'Microcode Version',
IF(dwh_inventory.storage_node.name is not null, dwh_inventory.storage_node.name, null) as 'Node',
IF(dwh_inventory.storage_node.name is not null, dwh_inventory.storage_node.model, dwh_inventory.storage.model) as 'Model',
IF(dwh_inventory.storage_node.name is not null, dwh_inventory.storage_node.serialnumber, dwh_inventory.storage.serialnumber) as 'Serial Number',
dwh_inventory.storage_pool.name as 'Pool/Aggregate',
IF(dwh_inventory.storage_pool.usesFlashPools=1,'Yes','No') as 'Flash Pool',
dwh_inventory.storage_pool.redundancy as 'Redundancy',
dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024 as 'Total Allocated (GB)',
dwh_inventory.storage_pool.totalUsedCapacityMB/1024 as 'Total Used (GB)',

dwh_inventory.storage_node.id as nodeid,
dwh_inventory.storage_pool.id as poolid


FROM dwh_inventory.storage
JOIN dwh_inventory.storage_node
ON dwh_inventory.storage.id=dwh_inventory.storage_node.storageid
JOIN dwh_inventory.storage_node_to_storage_pool
ON dwh_inventory.storage_node.id=dwh_inventory.storage_node_to_storage_pool.storagenodeid
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.storage_node_to_storage_pool.storagepoolid

WHERE dwh_inventory.storage.manufacturer='netapp'

GROUP BY dwh_inventory.storage.id, dwh_inventory.storage_node.id, dwh_inventory.storage_pool.id ) X











</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Family"/><mdProjectedItem name="Microcode Version"/><mdProjectedItem name="Node"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Pool/Aggregate"/><mdProjectedItem name="Flash Pool"/><mdProjectedItem name="Redundancy"/><mdProjectedItem name="Total Allocated (GB)"/><mdProjectedItem name="Total Used (GB)"/><mdProjectedItem name="nodeid"/><mdProjectedItem name="poolid"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL1].[Vendor]</expression></dataItem><dataItem name="Family"><expression>[SQL1].[Family]</expression></dataItem><dataItem name="Microcode Version"><expression>[SQL1].[Microcode Version]</expression></dataItem><dataItem name="Node"><expression>[SQL1].[Node]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL1].[Serial Number]</expression></dataItem><dataItem name="Pool/Aggregate" label="Aggregate"><expression>[SQL1].[Pool/Aggregate]</expression></dataItem><dataItem name="nodeid"><expression>[SQL1].[nodeid]</expression></dataItem><dataItem name="poolid"><expression>[SQL1].[poolid]</expression></dataItem><dataItem name="Total Allocated (GB)" aggregate="total" label="Allocated (GB)"><expression>[SQL1].[Total Allocated (GB)]</expression></dataItem><dataItem name="Total Used (GB)" aggregate="total" label="Used (GB)"><expression>[SQL1].[Total Used (GB)]</expression></dataItem><dataItem name="Flash Pool"><expression>[SQL1].[Flash Pool]</expression></dataItem><dataItem name="Redundancy"><expression>[SQL1].[Redundancy]</expression></dataItem></selection>
		</query><query name="NetApp Volume">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT DISTINCT
dwh_inventory.storage_node_to_internal_volume.storagenodeid as vnodeid,
dwh_inventory.internal_volume.storagepoolid as vpoolid,
dwh_inventory.internal_volume.name as 'Volume',
IF(dwh_inventory.internal_volume.thinprovisioned=1,'Yes','No') as 'Thin Provisioned',
IF(dwh_inventory.internal_volume.spaceGuarantee='NONE','No','Yes') as 'Space Guarantee',
dwh_inventory.internal_volume.protectionType as 'Protection Type',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 as 'Total Volume Allocated (GB)',
dwh_inventory.internal_volume.totalUsedCapacityFromDeviceMB/1024 as 'Total Volume Used (GB)'

FROM dwh_inventory.internal_volume
JOIN dwh_inventory.storage_node_to_internal_volume
ON dwh_inventory.internal_volume.id=dwh_inventory.storage_node_to_internal_volume.internalvolumeid
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.internal_volume.storagepoolid

GROUP BY dwh_inventory.storage_node_to_internal_volume.storagenodeid, dwh_inventory.internal_volume.id, dwh_inventory.internal_volume.storagepoolid</sqlText>
		<mdProjectedItems><mdProjectedItem name="vnodeid"/><mdProjectedItem name="vpoolid"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Thin Provisioned"/><mdProjectedItem name="Space Guarantee"/><mdProjectedItem name="Protection Type"/><mdProjectedItem name="Total Volume Allocated (GB)"/><mdProjectedItem name="Total Volume Used (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="vnodeid"><expression>[SQL2].[vnodeid]</expression></dataItem><dataItem name="vpoolid"><expression>[SQL2].[vpoolid]</expression></dataItem><dataItem name="Volume"><expression>[SQL2].[Volume]</expression></dataItem><dataItem name="Thin Provisioned"><expression>[SQL2].[Thin Provisioned]</expression></dataItem><dataItem name="Space Guarantee"><expression>[SQL2].[Space Guarantee]</expression></dataItem><dataItem name="Protection Type"><expression>[SQL2].[Protection Type]</expression></dataItem><dataItem name="Total Volume Allocated (GB)" label="Allocated (GB)"><expression>[SQL2].[Total Volume Allocated (GB)]</expression></dataItem><dataItem name="Total Volume Used (GB)" label="Used (GB)"><expression>[SQL2].[Total Volume Used (GB)]</expression></dataItem></selection>
		</query><query name="NetApp Disk">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT DISTINCT
dwh_inventory.storage_node_to_storage_pool.storagenodeid as dnodeid,
dwh_inventory.storage_node_to_storage_pool.storagepoolid as dpoolid,
dwh_inventory.disk.name as 'Disk',
dwh_inventory.disk.type as 'Disk Type',
dwh_inventory.disk.speed as ' Disk Speed',
dwh_inventory.disk.role as 'Disk Role',
dwh_inventory.disk.status as 'Disk Status',
dwh_inventory.disk.location as 'Location',
dwh_inventory.disk.capacityGB as 'Capacity (GB)'

FROM dwh_inventory.disk
JOIN dwh_inventory.storage_pool_to_disk
ON dwh_inventory.disk.id=dwh_inventory.storage_pool_to_disk.diskid
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.storage_pool_to_disk.storagepoolid
JOIN dwh_inventory.storage_node_to_storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.storage_node_to_storage_pool.storagepoolid


GROUP BY dwh_inventory.storage_node_to_storage_pool.storagenodeid, dwh_inventory.storage_node_to_storage_pool.storagepoolid, dwh_inventory.disk.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="dnodeid"/><mdProjectedItem name="dpoolid"/><mdProjectedItem name="Disk"/><mdProjectedItem name="Disk Type"/><mdProjectedItem name="Disk Speed"/><mdProjectedItem name="Disk Role"/><mdProjectedItem name="Disk Status"/><mdProjectedItem name="Location"/><mdProjectedItem name="Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="dnodeid"><expression>[SQL3].[dnodeid]</expression></dataItem><dataItem name="dpoolid"><expression>[SQL3].[dpoolid]</expression></dataItem><dataItem name="Disk"><expression>[SQL3].[Disk]</expression></dataItem><dataItem name="Disk Type"><expression>[SQL3].[Disk Type]</expression></dataItem><dataItem name="Disk Speed"><expression>[SQL3].[Disk Speed]</expression></dataItem><dataItem name="Disk Role"><expression>[SQL3].[Disk Role]</expression></dataItem><dataItem name="Disk Status"><expression>[SQL3].[Disk Status]</expression></dataItem><dataItem name="Location"><expression>[SQL3].[Location]</expression></dataItem><dataItem name="Capacity (GB)"><expression>[SQL3].[Capacity (GB)]</expression></dataItem></selection>
		</query><query name="MultiVendor Storage">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
*
FROM
(

SELECT
dwh_inventory.storage.name as 'Storage Name',
dwh_inventory.storage.manufacturer as 'Vendor',
dwh_inventory.storage.family as 'Family',
dwh_inventory.storage.microcodeversion as 'Microcode Version',
dwh_inventory.storage.model as 'Model',
dwh_inventory.storage.serialnumber as 'Serial Number',
dwh_inventory.storage_pool.name as 'Storage Pool',
dwh_inventory.storage_pool.redundancy as 'Redundancy',
dwh_inventory.storage_pool.totalAllocatedCapacityMB/1024 as 'Total Allocated (GB)',
dwh_inventory.storage_pool.totalUsedCapacityMB/1024 as 'Total Used (GB)',
dwh_inventory.storage_pool.id as poolid,
dwh_inventory.storage.id as storageid


FROM dwh_inventory.storage
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage.id=dwh_inventory.storage_pool.storageid

WHERE dwh_inventory.storage.manufacturer&lt;&gt;'netapp'

GROUP BY dwh_inventory.storage.id, dwh_inventory.storage_pool.id ) X











</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Family"/><mdProjectedItem name="Microcode Version"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Storage Pool"/><mdProjectedItem name="Redundancy"/><mdProjectedItem name="Total Allocated (GB)"/><mdProjectedItem name="Total Used (GB)"/><mdProjectedItem name="poolid"/><mdProjectedItem name="storageid"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL4].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL4].[Vendor]</expression></dataItem><dataItem name="Family"><expression>[SQL4].[Family]</expression></dataItem><dataItem name="Microcode Version"><expression>[SQL4].[Microcode Version]</expression></dataItem><dataItem name="Model"><expression>[SQL4].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL4].[Serial Number]</expression></dataItem><dataItem name="Storage Pool"><expression>[SQL4].[Storage Pool]</expression></dataItem><dataItem name="Redundancy"><expression>[SQL4].[Redundancy]</expression></dataItem><dataItem name="Total Allocated (GB)"><expression>[SQL4].[Total Allocated (GB)]</expression></dataItem><dataItem name="Total Used (GB)"><expression>[SQL4].[Total Used (GB)]</expression></dataItem><dataItem name="poolid"><expression>[SQL4].[poolid]</expression></dataItem><dataItem name="storageid"><expression>[SQL4].[storageid]</expression></dataItem></selection>
		</query><query name="MultiVendor Volume">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_inventory.storage_pool.id as vpoolid,
dwh_inventory.storage.id as storageid,
dwh_inventory.volume.name as 'Volume',
IF(dwh_inventory.volume.thinProvisioned=1,'Yes','No') as 'Thin Provisioned',
dwh_inventory.volume.capacitymb/1024 as 'Capacity (GB)',
dwh_inventory.volume.consumedCapacitymb/1024 as 'Used (GB)',
dwh_inventory.volume.type as 'Type',
IF(dwh_inventory.volume.protectionType='N/A', 'None', dwh_inventory.volume.protectionType) as 'Protection Type',
IF(dwh_inventory.volume.replicaSource=1, 'Replica Source', IF(dwh_inventory.volume.replicaTarget=1, 'Replica Target', 'None')) as 'Replica Status'

FROM dwh_inventory.volume
JOIN dwh_inventory.storage
ON dwh_inventory.storage.id=dwh_inventory.volume.storageid
JOIN dwh_inventory.volume_in_storage_pool
ON dwh_inventory.volume.id=dwh_inventory.volume_in_storage_pool.volumeid
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.volume_in_storage_pool.storagepoolid

GROUP BY dwh_inventory.volume.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="vpoolid"/><mdProjectedItem name="storageid"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Thin Provisioned"/><mdProjectedItem name="Capacity (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Type"/><mdProjectedItem name="Protection Type"/><mdProjectedItem name="Replica Status"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="vpoolid"><expression>[SQL5].[vpoolid]</expression></dataItem><dataItem name="storageid"><expression>[SQL5].[storageid]</expression></dataItem><dataItem name="Volume"><expression>[SQL5].[Volume]</expression></dataItem><dataItem name="Thin Provisioned"><expression>[SQL5].[Thin Provisioned]</expression></dataItem><dataItem name="Capacity (GB)"><expression>[SQL5].[Capacity (GB)]</expression></dataItem><dataItem name="Used (GB)"><expression>[SQL5].[Used (GB)]</expression></dataItem><dataItem name="Type"><expression>[SQL5].[Type]</expression></dataItem><dataItem name="Protection Type"><expression>[SQL5].[Protection Type]</expression></dataItem><dataItem name="Replica Status"><expression>[SQL5].[Replica Status]</expression></dataItem></selection>
		</query><query name="MultiVendor Disk">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT DISTINCT
dwh_inventory.storage.id as storageid,
dwh_inventory.storage_pool.id as poolid,
dwh_inventory.disk.name as 'Disk',
dwh_inventory.disk.type as 'Disk Type',
dwh_inventory.disk.speed as ' Disk Speed',
dwh_inventory.disk.role as 'Disk Role',
dwh_inventory.disk.status as 'Disk Status',
dwh_inventory.disk.location as 'Location',
dwh_inventory.disk.capacityGB as 'Capacity (GB)'

FROM dwh_inventory.disk
JOIN dwh_inventory.storage
ON dwh_inventory.storage.id=dwh_inventory.disk.storageid
JOIN dwh_inventory.storage_pool_to_disk
ON dwh_inventory.disk.id=dwh_inventory.storage_pool_to_disk.diskid
JOIN dwh_inventory.storage_pool
ON dwh_inventory.storage_pool.id=dwh_inventory.storage_pool_to_disk.storagepoolid


GROUP BY dwh_inventory.storage.id, dwh_inventory.storage_pool.id , dwh_inventory.disk.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="storageid"/><mdProjectedItem name="poolid"/><mdProjectedItem name="Disk"/><mdProjectedItem name="Disk Type"/><mdProjectedItem name="Disk Speed"/><mdProjectedItem name="Disk Role"/><mdProjectedItem name="Disk Status"/><mdProjectedItem name="Location"/><mdProjectedItem name="Capacity (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="storageid"><expression>[SQL6].[storageid]</expression></dataItem><dataItem name="poolid"><expression>[SQL6].[poolid]</expression></dataItem><dataItem name="Disk"><expression>[SQL6].[Disk]</expression></dataItem><dataItem name="Disk Type"><expression>[SQL6].[Disk Type]</expression></dataItem><dataItem name="Disk Speed"><expression>[SQL6].[Disk Speed]</expression></dataItem><dataItem name="Disk Role"><expression>[SQL6].[Disk Role]</expression></dataItem><dataItem name="Disk Status"><expression>[SQL6].[Disk Status]</expression></dataItem><dataItem name="Location"><expression>[SQL6].[Location]</expression></dataItem><dataItem name="Capacity (GB)"><expression>[SQL6].[Capacity (GB)]</expression></dataItem></selection>
		</query></queries></report>